Here we import the Victoria spatial data for suburbs and the expentiture dataset. Once completed this will give a value per suburb in a format that can be mapped. The expenditure dataset is a bit horible to get location names out of and there are a mix of suburb names, LGA names, regions and a mixof other spatial scales. Cleaning this is endless and I have to draw the line and move on.
## OGR data source with driver: ESRI Shapefile
## Source: "mapping", layer: "SSC_simple"
## with 8529 features
## It has 4 fields
Some expenditure goes to multiple locations so this needs to be split out first. Then expenditure is summed for single locations.
Some suburb names needed to be modified so that the Expenditure dataset and Suburbs spatial data would match. The plot below indicates the locations that have not been allocated to a suburb.
The population data is needed to calculate the expenditure per person for each Suburb. Again there is a problem with matching the location data. The State based Suburb data is not compatible with the ABS based population data. The ABS data contains roughly half the number of suburbs and so cannot be directly linked.
Merge is made on the ABS suburb ID
Here is the basic map. The data is in GeoJSON format so it can be saved and used outside of R.
I had hoped to capture some of the expenditure directed to LGA’s. Currently this is on hold.